# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月14日
"""
import openpyxl

myBook=openpyxl.load_workbook("录取表.xlsx")

myNewRows=[]

for mySheet in myBook:
	myNewRows+=[[myCell.value for myCell in myRow] for myRow in mySheet.rows][1:]
	print(myNewRows)
myNewSheet=myBook.create_sheet('录取表')
myNewSheet.append(['录取院校','专业','考生姓名','总分'])
for myRow in myNewRows:
	myNewSheet.append(myRow)
myBook.save('结果表-录取表.xlsx')